Graphical Designer

You can add transformation and lookup details to a mapping specification on the Graphical Designer tab.

Adding transformation details involves setting up:

  • Business rule
  • Extended business rule transformation

Ensure that you define business rules under the Transformations node for the same ETL Option as the Project ETL. For more information on defining business rules, refer to the Defining Transformations section.

Adding lookup details involves setting up:

  • Trans lookup condition
  • Lookup reference column
  • Lookup on

Ensure that you scan the required table in the Metadata Manager to set trans lookup condition.

Adding Transformation Details

To add business rules graphically, follow these steps:

  1. Click the Graphical Designer tab.
  2. Click .

    3. You can now edit the mapping specification graphically.

  3. Click the mapping link of the required column and expand the Properties pane.
  4. Expand the Transformation Details pane.
  5. Double-click the Value cell for Business Rule and select the required value.
  6. Click .

    7. The business rule is added to the mapping link. You can add business rules for multiple mapping links.

To add extended business rule transformations graphically, follow these steps:

  1. On the Graphical Designer tab, Click .

    2. The available options appear.

  2. Select the Extended Business Rule check box.
  3. Click the mapping link of the required column and expand the Transformation Details pane.
  4. Double-click the Value cell for Extended Business Rule Transformation.

    5. The Extended Transformation Rule Editor page appears.

  5. Select the pseudocode based on the Project ETL.

    6. For example, if the Project ETL is Informatica then select Informatica Pseudocode.

  6. Press Ctrl + Space keys.

    7. The available transformations appear.

    If the required transformation is not available in the list, use to create and update the transformations list.

  7. Double-click the required transformation.

    8. You can use to replace transformation name with pseudocode.

  8. Click .

    9. The extended business rule transformation is added to the mapping link. You can add extended business rule transformations to multiple mapping links.

Adding Lookup Details

To add lookup details graphically, follow these steps:

  1. On the Graphical Designer tab, click the mapping link of the required column and expand the Properties pane.
  2. Expand the Lookup Details pane.
  3. Drag the required table from the Metadata Tree View pane and drop it for Trans Lookup Condition.

    4. Once trans lookup condition is set, you can add lookup reference column and lookup on.

    To add lookup reference column, double-click the cell for Lookup Reference Column and select the required option.

    To add lookup on, double-click the cell against Lookup On and select the required option.

  4. Click .

    5. The lookup details are added to the mapping specification. You can add lookup details for multiple mapping links.